DROP TABLE IF EXISTS DECIMAL_PRECISION;

CREATE TABLE DECIMAL_PRECISION(`dec` decimal) 
ROW FORMAT DELIMITED
   FIELDS TERMINATED BY ' '
STORED AS TEXTFILE;

SELECT `dec` * 123456789012345678901234567890.123456789bd FROM DECIMAL_PRECISION;

DROP TABLE DECIMAL_PRECISION;
